﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetDetalleVentaByIdVenta')
	BEGIN
		DROP  Procedure  GetDetalleVentaByIdVenta
	END

GO

CREATE Procedure GetDetalleVentaByIdVenta

	(
		@idVenta int
	)

AS

BEGIN
	SET NOCOUNT ON
	
	SELECT
	[Cantida],
	[Descripcion],
	[IdBien],
	[IdVenta],
	[Monto]
	FROM [DetalleVenta] 
	WHERE [IdVenta] = @idVenta

	SET NOCOUNT OFF
END

GO


GRANT EXEC ON GetDetalleVentaByIdVenta TO PUBLIC

GO


